Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 933973 |
| Missing cells | 158318 |
| Missing cells (%) | 0.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 531.3 MiB |
| Average record size in memory | 596.5 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 14 |
| Boolean | 1 |
insurance_amt has constant value "0" | Constant |
finance_chgs has constant value "0" | Constant |
installment_chgs has constant value "0" | Constant |
tracker_chgs has constant value "0" | Constant |
insurance_recv has constant value "0" | Constant |
finance_chgs_recv has constant value "0" | Constant |
installment_chgs_recv has constant value "0" | Constant |
tracker_chgs_recv has constant value "0" | Constant |
install_due_date has a high cardinality: 3421 distinct values | High cardinality |
installment receiving date has a high cardinality: 2403 distinct values | High cardinality |
Loan Settelment_Date has a high cardinality: 99753 distinct values | High cardinality |
unit_id is highly correlated with insurance_amt and 7 other fields | High correlation |
business_proposal_no is highly correlated with ProductDescription | High correlation |
sub_proposal_no is highly correlated with insurance_amt and 7 other fields | High correlation |
install_no is highly correlated with markup_amt | High correlation |
principal_amt is highly correlated with markup_amt and 3 other fields | High correlation |
markup_amt is highly correlated with principal_amt and 4 other fields | High correlation |
principal_recv is highly correlated with principal_amt and 3 other fields | High correlation |
markup_recv is highly correlated with principal_amt and 5 other fields | High correlation |
os_principal is highly correlated with markup_recv and 2 other fields | High correlation |
os_markup is highly correlated with markup_recv and 1 other fields | High correlation |
session_id is highly correlated with business_proposal_no | High correlation |
insurance_amt is highly correlated with Status and 10 other fields | High correlation |
finance_chgs is highly correlated with insurance_amt and 10 other fields | High correlation |
installment_chgs is highly correlated with insurance_amt and 10 other fields | High correlation |
tracker_chgs is highly correlated with insurance_amt and 10 other fields | High correlation |
insurance_recv is highly correlated with insurance_amt and 10 other fields | High correlation |
finance_chgs_recv is highly correlated with insurance_amt and 10 other fields | High correlation |
installment_chgs_recv is highly correlated with insurance_amt and 10 other fields | High correlation |
tracker_chgs_recv is highly correlated with insurance_amt and 10 other fields | High correlation |
os_install_flag is highly correlated with markup_amt and 2 other fields | High correlation |
no_of_receipts is highly correlated with ProductDescription | High correlation |
Status is highly correlated with os_install_flag | High correlation |
ProductDescription is highly correlated with business_proposal_no and 7 other fields | High correlation |
installment receiving date has 158318 (17.0%) missing values | Missing |
session_id is highly skewed (γ1 = 23.00611905) | Skewed |
principal_amt has 30288 (3.2%) zeros | Zeros |
markup_amt has 19212 (2.1%) zeros | Zeros |
principal_recv has 178678 (19.1%) zeros | Zeros |
markup_recv has 170046 (18.2%) zeros | Zeros |
os_principal has 141632 (15.2%) zeros | Zeros |
os_markup has 137489 (14.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-08 09:10:23.008550 |
|---|---|
| Analysis finished | 2022-11-08 09:12:13.947584 |
| Duration | 1 minute and 50.94 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 124 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2523.575249 |
| Minimum | 205 |
|---|---|
| Maximum | 9042 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | 205 |
|---|---|
| 5-th percentile | 217 |
| Q1 | 319 |
| median | 612 |
| Q3 | 708 |
| 95-th percentile | 9039 |
| Maximum | 9042 |
| Range | 8837 |
| Interquartile range (IQR) | 389 |
Descriptive statistics
| Standard deviation | 3635.383255 |
|---|---|
| Coefficient of variation (CV) | 1.440568597 |
| Kurtosis | -0.4937699652 |
| Mean | 2523.575249 |
| Median Absolute Deviation (MAD) | 208 |
| Skewness | 1.223100723 |
| Sum | 2356951146 |
| Variance | 13216011.41 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 703 | 106690 | 11.4% |
| 301 | 51412 | 5.5% |
| 701 | 43539 | 4.7% |
| 603 | 42240 | 4.5% |
| 9041 | 42141 | 4.5% |
| 209 | 36038 | 3.9% |
| 9003 | 33255 | 3.6% |
| 612 | 24278 | 2.6% |
| 305 | 22292 | 2.4% |
| 313 | 21538 | 2.3% |
| Other values (114) | 510550 |
| Value | Count | Frequency (%) |
| 205 | 1003 | 0.1% |
| 209 | 36038 | |
| 210 | 1250 | 0.1% |
| 213 | 2599 | 0.3% |
| 214 | 2377 | 0.3% |
| 216 | 2765 | 0.3% |
| 217 | 1924 | 0.2% |
| 218 | 2397 | 0.3% |
| 219 | 7735 | 0.8% |
| 220 | 2372 | 0.3% |
| Value | Count | Frequency (%) |
| 9042 | 985 | 0.1% |
| 9041 | 42141 | |
| 9040 | 2002 | 0.2% |
| 9039 | 1885 | 0.2% |
| 9038 | 2546 | 0.3% |
| 9037 | 5447 | 0.6% |
| 9036 | 4210 | 0.5% |
| 9035 | 2195 | 0.2% |
| 9034 | 1272 | 0.1% |
| 9033 | 2074 | 0.2% |
| Distinct | 109476 |
|---|---|
| Distinct (%) | 11.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 291064.8987 |
| Minimum | 2 |
|---|---|
| Maximum | 715816 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 16094 |
| Q1 | 103262 |
| median | 232598 |
| Q3 | 533243 |
| 95-th percentile | 625792 |
| Maximum | 715816 |
| Range | 715814 |
| Interquartile range (IQR) | 429981 |
Descriptive statistics
| Standard deviation | 211295.7082 |
|---|---|
| Coefficient of variation (CV) | 0.7259401911 |
| Kurtosis | -1.331585463 |
| Mean | 291064.8987 |
| Median Absolute Deviation (MAD) | 163561 |
| Skewness | 0.3471036869 |
| Sum | 2.718467567 × 1011 |
| Variance | 4.464587631 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 283637 | 88 | < 0.1% |
| 283902 | 87 | < 0.1% |
| 230686 | 84 | < 0.1% |
| 231371 | 83 | < 0.1% |
| 229665 | 81 | < 0.1% |
| 224689 | 81 | < 0.1% |
| 183371 | 81 | < 0.1% |
| 283765 | 80 | < 0.1% |
| 225871 | 80 | < 0.1% |
| 226547 | 79 | < 0.1% |
| Other values (109466) | 933149 |
| Value | Count | Frequency (%) |
| 2 | 30 | |
| 13 | 18 | |
| 24 | 18 | |
| 25 | 18 | |
| 46 | 12 | < 0.1% |
| 56 | 33 | |
| 75 | 15 | |
| 82 | 30 | |
| 103 | 18 | |
| 108 | 18 |
| Value | Count | Frequency (%) |
| 715816 | 12 | |
| 714296 | 12 | |
| 711071 | 12 | |
| 710996 | 1 | < 0.1% |
| 710430 | 1 | < 0.1% |
| 709351 | 12 | |
| 709023 | 12 | |
| 707730 | 12 | |
| 707251 | 12 | |
| 705842 | 18 |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.992615418 |
| Minimum | 1 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.564502029 |
|---|---|
| Coefficient of variation (CV) | 0.7851500168 |
| Kurtosis | 7.092219018 |
| Mean | 1.992615418 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.351733863 |
| Sum | 1861049 |
| Variance | 2.447666599 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 509346 | |
| 2 | 203954 | |
| 3 | 99244 | 10.6% |
| 4 | 51413 | 5.5% |
| 5 | 29937 | 3.2% |
| 6 | 17245 | 1.8% |
| 7 | 9968 | 1.1% |
| 8 | 5515 | 0.6% |
| 9 | 3396 | 0.4% |
| 10 | 2003 | 0.2% |
| Other values (6) | 1952 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 509346 | |
| 2 | 203954 | |
| 3 | 99244 | 10.6% |
| 4 | 51413 | 5.5% |
| 5 | 29937 | 3.2% |
| 6 | 17245 | 1.8% |
| 7 | 9968 | 1.1% |
| 8 | 5515 | 0.6% |
| 9 | 3396 | 0.4% |
| 10 | 2003 | 0.2% |
| Value | Count | Frequency (%) |
| 16 | 12 | < 0.1% |
| 15 | 24 | < 0.1% |
| 14 | 68 | < 0.1% |
| 13 | 269 | < 0.1% |
| 12 | 396 | < 0.1% |
| 11 | 1183 | 0.1% |
| 10 | 2003 | 0.2% |
| 9 | 3396 | 0.4% |
| 8 | 5515 | |
| 7 | 9968 |
| Distinct | 36 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.79917942 |
| Minimum | 1 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 15 |
| Maximum | 36 |
| Range | 35 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.502865684 |
|---|---|
| Coefficient of variation (CV) | 0.6622660481 |
| Kurtosis | 0.2945002387 |
| Mean | 6.79917942 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.654949364 |
| Sum | 6350250 |
| Variance | 20.27579937 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 137345 | |
| 2 | 69625 | 7.5% |
| 3 | 66187 | 7.1% |
| 4 | 65873 | 7.1% |
| 5 | 65717 | 7.0% |
| 6 | 65543 | 7.0% |
| 7 | 65320 | 7.0% |
| 8 | 65315 | 7.0% |
| 9 | 65310 | 7.0% |
| 10 | 65251 | 7.0% |
| Other values (26) | 202487 |
| Value | Count | Frequency (%) |
| 1 | 137345 | |
| 2 | 69625 | |
| 3 | 66187 | |
| 4 | 65873 | |
| 5 | 65717 | |
| 6 | 65543 | |
| 7 | 65320 | |
| 8 | 65315 | |
| 9 | 65310 | |
| 10 | 65251 |
| Value | Count | Frequency (%) |
| 36 | 1 | < 0.1% |
| 35 | 2 | < 0.1% |
| 34 | 7 | < 0.1% |
| 33 | 11 | < 0.1% |
| 32 | 12 | < 0.1% |
| 31 | 18 | < 0.1% |
| 30 | 20 | < 0.1% |
| 29 | 30 | < 0.1% |
| 28 | 73 | |
| 27 | 164 |
| Distinct | 3421 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 72.1 MiB |
| [2019/07/15:12:00:00 AM] | 3770 |
|---|---|
| [2019/11/11:12:00:00 AM] | 3716 |
| [2019/06/10:12:00:00 AM] | 3637 |
| [2019/09/10:12:00:00 AM] | 3377 |
| [2019/12/16:12:00:00 AM] | 3366 |
| Other values (3416) |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Characters and Unicode
| Total characters | 22415352 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 397 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | [2014/03/07:12:00:00 AM] |
|---|---|
| 2nd row | [2014/04/07:12:00:00 AM] |
| 3rd row | [2014/05/07:12:00:00 AM] |
| 4th row | [2014/06/07:12:00:00 AM] |
| 5th row | [2014/07/07:12:00:00 AM] |
Common Values
| Value | Count | Frequency (%) |
| [2019/07/15:12:00:00 AM] | 3770 | 0.4% |
| [2019/11/11:12:00:00 AM] | 3716 | 0.4% |
| [2019/06/10:12:00:00 AM] | 3637 | 0.4% |
| [2019/09/10:12:00:00 AM] | 3377 | 0.4% |
| [2019/12/16:12:00:00 AM] | 3366 | 0.4% |
| [2019/08/10:12:00:00 AM] | 3366 | 0.4% |
| [2019/10/10:12:00:00 AM] | 3324 | 0.4% |
| [2019/08/15:12:00:00 AM] | 3252 | 0.3% |
| [2019/07/10:12:00:00 AM] | 3246 | 0.3% |
| [2019/01/10:12:00:00 AM] | 3170 | 0.3% |
| Other values (3411) | 899749 |
Length
| Value | Count | Frequency (%) |
| am | 933973 | |
| 2019/07/15:12:00:00 | 3770 | 0.2% |
| 2019/11/11:12:00:00 | 3716 | 0.2% |
| 2019/06/10:12:00:00 | 3637 | 0.2% |
| 2019/09/10:12:00:00 | 3377 | 0.2% |
| 2019/12/16:12:00:00 | 3366 | 0.2% |
| 2019/08/10:12:00:00 | 3366 | 0.2% |
| 2019/10/10:12:00:00 | 3324 | 0.2% |
| 2019/08/15:12:00:00 | 3252 | 0.2% |
| 2019/07/10:12:00:00 | 3246 | 0.2% |
| Other values (3412) | 902919 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6048323 | |
| : | 2801919 | |
| 1 | 2677045 | |
| 2 | 2501967 | |
| / | 1867946 | 8.3% |
| 933973 | 4.2% | |
| ] | 933973 | 4.2% |
| M | 933973 | 4.2% |
| A | 933973 | 4.2% |
| [ | 933973 | 4.2% |
| Other values (7) | 1848287 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 13075622 | |
| Other Punctuation | 4669865 | 20.8% |
| Uppercase Letter | 1867946 | 8.3% |
| Space Separator | 933973 | 4.2% |
| Close Punctuation | 933973 | 4.2% |
| Open Punctuation | 933973 | 4.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 6048323 | |
| 1 | 2677045 | |
| 2 | 2501967 | |
| 9 | 458588 | 3.5% |
| 8 | 354652 | 2.7% |
| 5 | 308938 | 2.4% |
| 6 | 215619 | 1.6% |
| 7 | 187191 | 1.4% |
| 4 | 168484 | 1.3% |
| 3 | 154815 | 1.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 2801919 | |
| / | 1867946 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 933973 | |
| A | 933973 |
Space Separator
| Value | Count | Frequency (%) |
| 933973 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 933973 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 20547406 | |
| Latin | 1867946 | 8.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 6048323 | |
| : | 2801919 | |
| 1 | 2677045 | |
| 2 | 2501967 | |
| / | 1867946 | 9.1% |
| 933973 | 4.5% | |
| ] | 933973 | 4.5% |
| [ | 933973 | 4.5% |
| 9 | 458588 | 2.2% |
| 8 | 354652 | 1.7% |
| Other values (5) | 1035047 | 5.0% |
Latin
| Value | Count | Frequency (%) |
| M | 933973 | |
| A | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 22415352 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 6048323 | |
| : | 2801919 | |
| 1 | 2677045 | |
| 2 | 2501967 | |
| / | 1867946 | 8.3% |
| 933973 | 4.2% | |
| ] | 933973 | 4.2% |
| M | 933973 | 4.2% |
| A | 933973 | 4.2% |
| [ | 933973 | 4.2% |
| Other values (7) | 1848287 | 8.2% |
| Distinct | 84625 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15623.19152 |
| Minimum | 0 |
|---|---|
| Maximum | 500000 |
| Zeros | 30288 |
| Zeros (%) | 3.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2748 |
| Q1 | 4674 |
| median | 7245 |
| Q3 | 11607.19 |
| 95-th percentile | 100000 |
| Maximum | 500000 |
| Range | 500000 |
| Interquartile range (IQR) | 6933.19 |
Descriptive statistics
| Standard deviation | 27785.52698 |
|---|---|
| Coefficient of variation (CV) | 1.778479572 |
| Kurtosis | 12.88508692 |
| Mean | 15623.19152 |
| Median Absolute Deviation (MAD) | 2974.19 |
| Skewness | 3.570812243 |
| Sum | 1.459163906 × 1010 |
| Variance | 772035509.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 30288 | 3.2% |
| 100000 | 20232 | 2.2% |
| 150000 | 17931 | 1.9% |
| 4231 | 6319 | 0.7% |
| 4890 | 6314 | 0.7% |
| 50000 | 5400 | 0.6% |
| 3351 | 5287 | 0.6% |
| 4755 | 5256 | 0.6% |
| 3484 | 5248 | 0.6% |
| 4574 | 5244 | 0.6% |
| Other values (84615) | 826454 |
| Value | Count | Frequency (%) |
| 0 | 30288 | |
| 1.66 | 1 | < 0.1% |
| 8.31 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 9.62 | 1 | < 0.1% |
| 11.37 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 18.08 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 27.25 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 500000 | 1 | < 0.1% |
| 400000 | 14 | |
| 390000 | 3 | < 0.1% |
| 325000 | 2 | < 0.1% |
| 320000 | 1 | < 0.1% |
| 300000 | 7 | |
| 260000 | 2 | < 0.1% |
| 252001.44 | 1 | < 0.1% |
| 250000 | 3 | < 0.1% |
| 228586.96 | 1 | < 0.1% |
| Distinct | 95952 |
|---|---|
| Distinct (%) | 10.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4746.85931 |
| Minimum | -5447 |
|---|---|
| Maximum | 169521 |
| Zeros | 19212 |
| Zeros (%) | 2.1% |
| Negative | 308 |
| Negative (%) | < 0.1% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | -5447 |
|---|---|
| 5-th percentile | 336 |
| Q1 | 1102 |
| median | 1986.5 |
| Q3 | 3781.4 |
| 95-th percentile | 25632 |
| Maximum | 169521 |
| Range | 174968 |
| Interquartile range (IQR) | 2679.4 |
Descriptive statistics
| Standard deviation | 8919.5076 |
|---|---|
| Coefficient of variation (CV) | 1.879033487 |
| Kurtosis | 15.62255874 |
| Mean | 4746.85931 |
| Median Absolute Deviation (MAD) | 1147.5 |
| Skewness | 3.782780903 |
| Sum | 4433438430 |
| Variance | 79557615.83 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19212 | 2.1% |
| 934 | 5468 | 0.6% |
| 447 | 5464 | 0.6% |
| 1418 | 5404 | 0.6% |
| 390 | 5304 | 0.6% |
| 1263 | 5296 | 0.6% |
| 1102 | 5293 | 0.6% |
| 1567 | 5285 | 0.6% |
| 578 | 5277 | 0.6% |
| 1849 | 5260 | 0.6% |
| Other values (95942) | 866710 |
| Value | Count | Frequency (%) |
| -5447 | 1 | < 0.1% |
| -4593 | 2 | < 0.1% |
| -4354 | 1 | < 0.1% |
| -3605 | 1 | < 0.1% |
| -3595 | 1 | < 0.1% |
| -3468 | 1 | < 0.1% |
| -3257 | 1 | < 0.1% |
| -3120 | 1 | < 0.1% |
| -3047 | 1 | < 0.1% |
| -3008 | 6 |
| Value | Count | Frequency (%) |
| 169521 | 1 | |
| 141538 | 1 | |
| 136000 | 2 | |
| 132000 | 1 | |
| 130805 | 1 | |
| 128586.96 | 1 | |
| 115671 | 1 | |
| 114600 | 1 | |
| 114194 | 1 | |
| 114000 | 2 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 933973 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 933973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 933973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 933973 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 933973 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 933973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 933973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 933973 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 933973 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 933973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 933973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 933973 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 933973 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 933973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 933973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 933973 |
| Distinct | 71739 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8648.759114 |
| Minimum | 0 |
|---|---|
| Maximum | 393699 |
| Zeros | 178678 |
| Zeros (%) | 19.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3484 |
| median | 5575 |
| Q3 | 9237 |
| 95-th percentile | 21199 |
| Maximum | 393699 |
| Range | 393699 |
| Interquartile range (IQR) | 5753 |
Descriptive statistics
| Standard deviation | 15916.15428 |
|---|---|
| Coefficient of variation (CV) | 1.840281833 |
| Kurtosis | 47.26952118 |
| Mean | 8648.759114 |
| Median Absolute Deviation (MAD) | 2889 |
| Skewness | 6.33987391 |
| Sum | 8077707496 |
| Variance | 253323966.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 178678 | 19.1% |
| 4231 | 6264 | 0.7% |
| 3351 | 5283 | 0.6% |
| 3484 | 5242 | 0.6% |
| 3622 | 5220 | 0.6% |
| 3766 | 5211 | 0.6% |
| 3915 | 5204 | 0.6% |
| 4070 | 5194 | 0.6% |
| 4399 | 5174 | 0.6% |
| 4574 | 5048 | 0.5% |
| Other values (71729) | 707455 |
| Value | Count | Frequency (%) |
| 0 | 178678 | |
| 0.38 | 1 | < 0.1% |
| 0.65 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 1.13 | 1 | < 0.1% |
| 1.25 | 1 | < 0.1% |
| 1.42 | 2 | < 0.1% |
| 1.5 | 1 | < 0.1% |
| 1.84 | 1 | < 0.1% |
| 3.4 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 393699 | 1 | |
| 390000 | 1 | |
| 325000 | 2 | |
| 300335 | 1 | |
| 300000 | 1 | |
| 276976 | 1 | |
| 260000 | 1 | |
| 253180.75 | 1 | |
| 250000 | 1 | |
| 209918 | 1 |
| Distinct | 75161 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2842.69503 |
| Minimum | -5447 |
|---|---|
| Maximum | 132000 |
| Zeros | 170046 |
| Zeros (%) | 18.2% |
| Negative | 170 |
| Negative (%) | < 0.1% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | -5447 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 615 |
| median | 1682.79 |
| Q3 | 3134 |
| 95-th percentile | 8006.91 |
| Maximum | 132000 |
| Range | 137447 |
| Interquartile range (IQR) | 2519 |
Descriptive statistics
| Standard deviation | 5358.862554 |
|---|---|
| Coefficient of variation (CV) | 1.885134528 |
| Kurtosis | 42.40248814 |
| Mean | 2842.69503 |
| Median Absolute Deviation (MAD) | 1224.79 |
| Skewness | 5.888681283 |
| Sum | 2655000406 |
| Variance | 28717407.87 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 170046 | 18.2% |
| 1418 | 5381 | 0.6% |
| 934 | 5308 | 0.6% |
| 1567 | 5272 | 0.6% |
| 1263 | 5258 | 0.6% |
| 1849 | 5253 | 0.6% |
| 1102 | 5238 | 0.6% |
| 1711 | 5219 | 0.6% |
| 759 | 5063 | 0.5% |
| 578 | 4581 | 0.5% |
| Other values (75151) | 717354 |
| Value | Count | Frequency (%) |
| -5447 | 1 | < 0.1% |
| -4593 | 2 | < 0.1% |
| -3008 | 5 | |
| -2783 | 4 | |
| -2737 | 1 | < 0.1% |
| -2604 | 1 | < 0.1% |
| -2424 | 1 | < 0.1% |
| -2282 | 2 | < 0.1% |
| -2006 | 1 | < 0.1% |
| -2000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 132000 | 1 | |
| 128586.96 | 1 | |
| 109578.42 | 1 | |
| 104701.44 | 1 | |
| 100750 | 1 | |
| 91616 | 1 | |
| 90893 | 1 | |
| 90314.38 | 1 | |
| 80255 | 1 | |
| 79532 | 1 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 933973 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 933973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 933973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 933973 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 933973 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 933973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 933973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 933973 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 933973 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 933973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 933973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 933973 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 933973 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 933973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 933973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 933973 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 933973 |
| Distinct | 87864 |
|---|---|
| Distinct (%) | 9.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51540.6945 |
| Minimum | -15198 |
|---|---|
| Maximum | 742642.32 |
| Zeros | 141632 |
| Zeros (%) | 15.2% |
| Negative | 330 |
| Negative (%) | < 0.1% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | -15198 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 14315.73 |
| median | 37545 |
| Q3 | 70055 |
| 95-th percentile | 157111 |
| Maximum | 742642.32 |
| Range | 757840.32 |
| Interquartile range (IQR) | 55739.27 |
Descriptive statistics
| Standard deviation | 57267.62988 |
|---|---|
| Coefficient of variation (CV) | 1.111114828 |
| Kurtosis | 8.958101204 |
| Mean | 51540.6945 |
| Median Absolute Deviation (MAD) | 26545.62 |
| Skewness | 2.471210633 |
| Sum | 4.813761706 × 1010 |
| Variance | 3279581432 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 141632 | 15.2% |
| 19162 | 5340 | 0.6% |
| 46649 | 5222 | 0.6% |
| 35777 | 5221 | 0.6% |
| 43165 | 5221 | 0.6% |
| 4890 | 5221 | 0.6% |
| 9833 | 5221 | 0.6% |
| 14588 | 5221 | 0.6% |
| 23561 | 5221 | 0.6% |
| 27792 | 5221 | 0.6% |
| Other values (87854) | 745232 |
| Value | Count | Frequency (%) |
| -15198 | 4 | |
| -14678 | 4 | |
| -14043 | 4 | |
| -13535 | 4 | |
| -13128 | 4 | |
| -12571 | 4 | |
| -12228 | 4 | |
| -11675 | 4 | |
| -11253 | 4 | |
| -10997 | 4 |
| Value | Count | Frequency (%) |
| 742642.32 | 1 | |
| 683780.69 | 1 | |
| 638319 | 1 | |
| 625904.63 | 1 | |
| 623375.69 | 1 | |
| 613676.07 | 1 | |
| 601169.62 | 1 | |
| 587938.28 | 1 | |
| 575277.94 | 1 | |
| 561055.49 | 1 |
| Distinct | 123635 |
|---|---|
| Distinct (%) | 13.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11012.99922 |
| Minimum | -5447 |
|---|---|
| Maximum | 351841.81 |
| Zeros | 137489 |
| Zeros (%) | 14.7% |
| Negative | 364 |
| Negative (%) | < 0.1% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | -5447 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1227 |
| median | 5806 |
| Q3 | 13783 |
| 95-th percentile | 39326.04 |
| Maximum | 351841.81 |
| Range | 357288.81 |
| Interquartile range (IQR) | 12556 |
Descriptive statistics
| Standard deviation | 16490.48086 |
|---|---|
| Coefficient of variation (CV) | 1.497365116 |
| Kurtosis | 25.79956055 |
| Mean | 11012.99922 |
| Median Absolute Deviation (MAD) | 5320 |
| Skewness | 3.946335704 |
| Sum | 1.028584392 × 1010 |
| Variance | 271935958.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 137489 | 14.7% |
| 2174 | 5313 | 0.6% |
| 6891 | 5292 | 0.6% |
| 8458 | 5247 | 0.6% |
| 1415 | 5235 | 0.6% |
| 837 | 5228 | 0.6% |
| 5473 | 5226 | 0.6% |
| 3108 | 5225 | 0.6% |
| 10169 | 5223 | 0.6% |
| 4210 | 5223 | 0.6% |
| Other values (123625) | 749272 |
| Value | Count | Frequency (%) |
| -5447 | 1 | |
| -4593 | 2 | |
| -4354 | 1 | |
| -3605 | 1 | |
| -3595 | 1 | |
| -3468 | 1 | |
| -3284 | 1 | |
| -3257 | 1 | |
| -3120 | 1 | |
| -3047 | 1 |
| Value | Count | Frequency (%) |
| 351841.81 | 1 | |
| 342217.61 | 1 | |
| 336772.94 | 1 | |
| 324441.14 | 1 | |
| 321391.37 | 1 | |
| 308521.72 | 1 | |
| 306009.8 | 1 | |
| 292983.41 | 1 | |
| 291124.41 | 1 | |
| 287480 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 912.2 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 775656 | |
| True | 158317 | 17.0% |
| Distinct | 2403 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 158318 |
| Missing (%) | 17.0% |
| Memory size | 64.7 MiB |
| [2019/08/16:12:00:00 AM] | 4432 |
|---|---|
| [2019/04/15:12:00:00 AM] | 3153 |
| [2019/06/10:12:00:00 AM] | 3118 |
| [2019/09/11:12:00:00 AM] | 3113 |
| [2020/07/06:12:00:00 AM] | 2931 |
| Other values (2398) |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Characters and Unicode
| Total characters | 18615720 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 192 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | [2014/03/08:12:00:00 AM] |
|---|---|
| 2nd row | [2014/04/07:12:00:00 AM] |
| 3rd row | [2014/05/07:12:00:00 AM] |
| 4th row | [2014/06/10:12:00:00 AM] |
| 5th row | [2014/07/08:12:00:00 AM] |
Common Values
| Value | Count | Frequency (%) |
| [2019/08/16:12:00:00 AM] | 4432 | 0.5% |
| [2019/04/15:12:00:00 AM] | 3153 | 0.3% |
| [2019/06/10:12:00:00 AM] | 3118 | 0.3% |
| [2019/09/11:12:00:00 AM] | 3113 | 0.3% |
| [2020/07/06:12:00:00 AM] | 2931 | 0.3% |
| [2018/06/19:12:00:00 AM] | 2888 | 0.3% |
| [2019/02/11:12:00:00 AM] | 2858 | 0.3% |
| [2019/09/16:12:00:00 AM] | 2854 | 0.3% |
| [2019/07/15:12:00:00 AM] | 2818 | 0.3% |
| [2019/08/19:12:00:00 AM] | 2747 | 0.3% |
| Other values (2393) | 744743 | |
| (Missing) | 158318 | 17.0% |
Length
| Value | Count | Frequency (%) |
| am | 775655 | |
| 2019/08/16:12:00:00 | 4432 | 0.3% |
| 2019/04/15:12:00:00 | 3153 | 0.2% |
| 2019/06/10:12:00:00 | 3118 | 0.2% |
| 2019/09/11:12:00:00 | 3113 | 0.2% |
| 2020/07/06:12:00:00 | 2931 | 0.2% |
| 2018/06/19:12:00:00 | 2888 | 0.2% |
| 2019/02/11:12:00:00 | 2858 | 0.2% |
| 2019/09/16:12:00:00 | 2854 | 0.2% |
| 2019/07/15:12:00:00 | 2818 | 0.2% |
| Other values (2394) | 747490 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4918669 | |
| : | 2326965 | |
| 1 | 2221800 | |
| 2 | 2086627 | |
| / | 1551310 | 8.3% |
| 775655 | 4.2% | |
| ] | 775655 | 4.2% |
| M | 775655 | 4.2% |
| A | 775655 | 4.2% |
| [ | 775655 | 4.2% |
| Other values (7) | 1632074 | 8.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10859170 | |
| Other Punctuation | 3878275 | 20.8% |
| Uppercase Letter | 1551310 | 8.3% |
| Space Separator | 775655 | 4.2% |
| Close Punctuation | 775655 | 4.2% |
| Open Punctuation | 775655 | 4.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4918669 | |
| 1 | 2221800 | |
| 2 | 2086627 | |
| 9 | 397592 | 3.7% |
| 8 | 334136 | 3.1% |
| 5 | 225466 | 2.1% |
| 6 | 194007 | 1.8% |
| 7 | 185891 | 1.7% |
| 4 | 151315 | 1.4% |
| 3 | 143667 | 1.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 2326965 | |
| / | 1551310 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 775655 | |
| A | 775655 |
Space Separator
| Value | Count | Frequency (%) |
| 775655 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 775655 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 775655 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17064410 | |
| Latin | 1551310 | 8.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4918669 | |
| : | 2326965 | |
| 1 | 2221800 | |
| 2 | 2086627 | |
| / | 1551310 | 9.1% |
| 775655 | 4.5% | |
| ] | 775655 | 4.5% |
| [ | 775655 | 4.5% |
| 9 | 397592 | 2.3% |
| 8 | 334136 | 2.0% |
| Other values (5) | 900346 | 5.3% |
Latin
| Value | Count | Frequency (%) |
| M | 775655 | |
| A | 775655 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18615720 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4918669 | |
| : | 2326965 | |
| 1 | 2221800 | |
| 2 | 2086627 | |
| / | 1551310 | 8.3% |
| 775655 | 4.2% | |
| ] | 775655 | 4.2% |
| M | 775655 | 4.2% |
| A | 775655 | 4.2% |
| [ | 775655 | 4.2% |
| Other values (7) | 1632074 | 8.8% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| 0 | |
|---|---|
| 1 | |
| 77 | 2273 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.002433689 |
| Min length | 1 |
Characters and Unicode
| Total characters | 936246 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 543315 | |
| 1 | 388385 | |
| 77 | 2273 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 543315 | |
| 1 | 388385 | |
| 77 | 2273 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 543315 | |
| 1 | 388385 | |
| 7 | 4546 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 936246 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 543315 | |
| 1 | 388385 | |
| 7 | 4546 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 936246 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 543315 | |
| 1 | 388385 | |
| 7 | 4546 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 936246 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 543315 | |
| 1 | 388385 | |
| 7 | 4546 | 0.5% |
| Distinct | 88569 |
|---|---|
| Distinct (%) | 9.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1300791.729 |
| Minimum | 7 |
|---|---|
| Maximum | 99099099 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.1 MiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 34663 |
| Q1 | 439770 |
| median | 586951 |
| Q3 | 1769027 |
| 95-th percentile | 3904137 |
| Maximum | 99099099 |
| Range | 99099092 |
| Interquartile range (IQR) | 1329257 |
Descriptive statistics
| Standard deviation | 3827095.925 |
|---|---|
| Coefficient of variation (CV) | 2.94212812 |
| Kurtosis | 584.1910437 |
| Mean | 1300791.729 |
| Median Absolute Deviation (MAD) | 436499 |
| Skewness | 23.00611905 |
| Sum | 1.214904354 × 1012 |
| Variance | 1.464666322 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 586951 | 97616 | 10.5% |
| 439798 | 43060 | 4.6% |
| 439797 | 37710 | 4.0% |
| 500039 | 37179 | 4.0% |
| 499665 | 33086 | 3.5% |
| 653770 | 32044 | 3.4% |
| 439770 | 27814 | 3.0% |
| 546389 | 19131 | 2.0% |
| 34635 | 8490 | 0.9% |
| 34671 | 8199 | 0.9% |
| Other values (88559) | 589644 |
| Value | Count | Frequency (%) |
| 7 | 3989 | |
| 235 | 1 | < 0.1% |
| 285 | 1 | < 0.1% |
| 389 | 2 | < 0.1% |
| 404 | 22 | < 0.1% |
| 460 | 2 | < 0.1% |
| 753 | 1 | < 0.1% |
| 837 | 5 | < 0.1% |
| 898 | 3 | < 0.1% |
| 945 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99099099 | 1286 | |
| 20200311 | 1 | < 0.1% |
| 4721204 | 1 | < 0.1% |
| 4721132 | 1 | < 0.1% |
| 4721004 | 4 | < 0.1% |
| 4720970 | 2 | < 0.1% |
| 4720693 | 2 | < 0.1% |
| 4720590 | 1 | < 0.1% |
| 4720547 | 2 | < 0.1% |
| 4720530 | 1 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.7 MiB |
| E | |
|---|---|
| X |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 933973 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | X |
|---|---|
| 2nd row | X |
| 3rd row | X |
| 4th row | X |
| 5th row | X |
Common Values
| Value | Count | Frequency (%) |
| E | 573814 | |
| X | 360159 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| e | 573814 | |
| x | 360159 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 573814 | |
| X | 360159 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 933973 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 573814 | |
| X | 360159 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 933973 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 573814 | |
| X | 360159 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 933973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 573814 | |
| X | 360159 |
| Distinct | 99753 |
|---|---|
| Distinct (%) | 10.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 72.1 MiB |
| [2018/06/19:12:00:00 AM] | 902 |
|---|---|
| [2019/11/14:12:00:00 AM] | 893 |
| [2018/02/28:12:00:00 AM] | 818 |
| [2018/12/31:12:00:00 AM] | 787 |
| [2018/11/12:12:00:00 AM] | 749 |
| Other values (99748) |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Characters and Unicode
| Total characters | 22415352 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 53149 ? |
|---|---|
| Unique (%) | 5.7% |
Sample
| 1st row | [2015/02/16:12:00:00 AM] |
|---|---|
| 2nd row | [2015/02/16:12:00:00 AM] |
| 3rd row | [2015/02/16:12:00:00 AM] |
| 4th row | [2015/02/16:12:00:00 AM] |
| 5th row | [2015/02/16:12:00:00 AM] |
Common Values
| Value | Count | Frequency (%) |
| [2018/06/19:12:00:00 AM] | 902 | 0.1% |
| [2019/11/14:12:00:00 AM] | 893 | 0.1% |
| [2018/02/28:12:00:00 AM] | 818 | 0.1% |
| [2018/12/31:12:00:00 AM] | 787 | 0.1% |
| [2018/11/12:12:00:00 AM] | 749 | 0.1% |
| [2018/10/17:12:00:00 AM] | 744 | 0.1% |
| [2019/11/15:12:00:00 AM] | 715 | 0.1% |
| [2016/10/17:12:00:00 AM] | 705 | 0.1% |
| [2018/07/17:12:00:00 AM] | 704 | 0.1% |
| [2018/04/30:12:00:00 AM] | 701 | 0.1% |
| Other values (99743) | 926255 |
Length
| Value | Count | Frequency (%) |
| am | 516327 | |
| pm | 417646 | |
| 2018/06/19:12:00:00 | 902 | < 0.1% |
| 2019/11/14:12:00:00 | 893 | < 0.1% |
| 2018/02/28:12:00:00 | 818 | < 0.1% |
| 2018/12/31:12:00:00 | 787 | < 0.1% |
| 2018/11/12:12:00:00 | 749 | < 0.1% |
| 2018/10/17:12:00:00 | 744 | < 0.1% |
| 2019/11/15:12:00:00 | 715 | < 0.1% |
| 2016/10/17:12:00:00 | 705 | < 0.1% |
| Other values (99729) | 927660 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4373506 | |
| : | 2801919 | |
| 2 | 2572566 | |
| 1 | 2571689 | |
| / | 1867946 | |
| [ | 933973 | 4.2% |
| ] | 933973 | 4.2% |
| M | 933973 | 4.2% |
| 933973 | 4.2% | |
| 9 | 678044 | 3.0% |
| Other values (8) | 3813790 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 13075622 | |
| Other Punctuation | 4669865 | 20.8% |
| Uppercase Letter | 1867946 | 8.3% |
| Open Punctuation | 933973 | 4.2% |
| Close Punctuation | 933973 | 4.2% |
| Space Separator | 933973 | 4.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4373506 | |
| 2 | 2572566 | |
| 1 | 2571689 | |
| 9 | 678044 | 5.2% |
| 5 | 599821 | 4.6% |
| 3 | 596840 | 4.6% |
| 4 | 554704 | 4.2% |
| 8 | 447844 | 3.4% |
| 6 | 377475 | 2.9% |
| 7 | 303133 | 2.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 933973 | |
| A | 516327 | |
| P | 417646 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 2801919 | |
| / | 1867946 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 933973 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 933973 |
Space Separator
| Value | Count | Frequency (%) |
| 933973 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 20547406 | |
| Latin | 1867946 | 8.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4373506 | |
| : | 2801919 | |
| 2 | 2572566 | |
| 1 | 2571689 | |
| / | 1867946 | |
| [ | 933973 | 4.5% |
| ] | 933973 | 4.5% |
| 933973 | 4.5% | |
| 9 | 678044 | 3.3% |
| 5 | 599821 | 2.9% |
| Other values (5) | 2279996 |
Latin
| Value | Count | Frequency (%) |
| M | 933973 | |
| A | 516327 | |
| P | 417646 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 22415352 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4373506 | |
| : | 2801919 | |
| 2 | 2572566 | |
| 1 | 2571689 | |
| / | 1867946 | |
| [ | 933973 | 4.2% |
| ] | 933973 | 4.2% |
| M | 933973 | 4.2% |
| 933973 | 4.2% | |
| 9 | 678044 | 3.0% |
| Other values (8) | 3813790 |
| Distinct | 36 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 76.4 MiB |
| FINCA KAROBARI KARZA BASIC | |
|---|---|
| FINCA KAROBARI KARZA BASIC 12 MONTHS | |
| FINCA MAWESHI KARZA BASIC | |
| FINCA MAWESHI KARZA BASIC 12 MONTHS | |
| FINCA KAROBARI KARZA PLUS | |
| Other values (31) |
Length
| Max length | 45 |
|---|---|
| Median length | 44 |
| Mean length | 28.81792514 |
| Min length | 18 |
Characters and Unicode
| Total characters | 26915164 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FINCA KAROBARI KARZA BASIC |
|---|---|
| 2nd row | FINCA KAROBARI KARZA BASIC |
| 3rd row | FINCA KAROBARI KARZA BASIC |
| 4th row | FINCA KAROBARI KARZA BASIC |
| 5th row | FINCA KAROBARI KARZA BASIC |
Common Values
| Value | Count | Frequency (%) |
| FINCA KAROBARI KARZA BASIC | 369917 | |
| FINCA KAROBARI KARZA BASIC 12 MONTHS | 141831 | 15.2% |
| FINCA MAWESHI KARZA BASIC | 90532 | 9.7% |
| FINCA MAWESHI KARZA BASIC 12 MONTHS | 70989 | 7.6% |
| FINCA KAROBARI KARZA PLUS | 50756 | 5.4% |
| FINCA KASHTKAR KARZA BASIC | 45007 | 4.8% |
| FINCA MAWESHI KARZA FATTENING | 28344 | 3.0% |
| FINCA MAWESHI KARZA PLUS | 27961 | 3.0% |
| FINCA NISWAN KARZA 12 MONTHS | 23058 | 2.5% |
| FINCA KAROBARI KARZA PLUS 12 MONTHS | 21674 | 2.3% |
| Other values (26) | 63904 | 6.8% |
Length
| Value | Count | Frequency (%) |
| finca | 933537 | |
| karza | 933443 | |
| basic | 735567 | |
| karobari | 604192 | |
| months | 316447 | 7.3% |
| 12 | 273640 | 6.3% |
| maweshi | 246297 | 5.7% |
| plus | 131844 | 3.0% |
| kashtkar | 46984 | 1.1% |
| niswan | 33032 | 0.8% |
| Other values (21) | 79465 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 5154578 | |
| 3428496 | ||
| I | 2587057 | |
| R | 2189035 | |
| C | 1669540 | 6.2% |
| K | 1631603 | 6.1% |
| S | 1513007 | 5.6% |
| N | 1373406 | 5.1% |
| B | 1339795 | 5.0% |
| F | 966752 | 3.6% |
| Other values (23) | 5061895 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 22863102 | |
| Space Separator | 3428496 | 12.7% |
| Decimal Number | 623347 | 2.3% |
| Dash Punctuation | 161 | < 0.1% |
| Other Punctuation | 58 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 5154578 | |
| I | 2587057 | |
| R | 2189035 | |
| C | 1669540 | 7.3% |
| K | 1631603 | 7.1% |
| S | 1513007 | 6.6% |
| N | 1373406 | 6.0% |
| B | 1339795 | 5.9% |
| F | 966752 | 4.2% |
| Z | 936381 | 4.1% |
| Other values (13) | 3501948 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 306361 | |
| 2 | 274143 | |
| 8 | 18554 | 3.0% |
| 5 | 14167 | 2.3% |
| 6 | 9583 | 1.5% |
| 4 | 503 | 0.1% |
| 3 | 36 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 3428496 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 161 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 58 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 22863102 | |
| Common | 4052062 | 15.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 5154578 | |
| I | 2587057 | |
| R | 2189035 | |
| C | 1669540 | 7.3% |
| K | 1631603 | 7.1% |
| S | 1513007 | 6.6% |
| N | 1373406 | 6.0% |
| B | 1339795 | 5.9% |
| F | 966752 | 4.2% |
| Z | 936381 | 4.1% |
| Other values (13) | 3501948 |
Common
| Value | Count | Frequency (%) |
| 3428496 | ||
| 1 | 306361 | 7.6% |
| 2 | 274143 | 6.8% |
| 8 | 18554 | 0.5% |
| 5 | 14167 | 0.3% |
| 6 | 9583 | 0.2% |
| 4 | 503 | < 0.1% |
| - | 161 | < 0.1% |
| / | 58 | < 0.1% |
| 3 | 36 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26915164 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 5154578 | |
| 3428496 | ||
| I | 2587057 | |
| R | 2189035 | |
| C | 1669540 | 6.2% |
| K | 1631603 | 6.1% |
| S | 1513007 | 5.6% |
| N | 1373406 | 5.1% |
| B | 1339795 | 5.0% |
| F | 966752 | 3.6% |
| Other values (23) | 5061895 |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| unit_id | business_proposal_no | sub_proposal_no | install_no | install_due_date | principal_amt | markup_amt | insurance_amt | finance_chgs | installment_chgs | tracker_chgs | principal_recv | markup_recv | insurance_recv | finance_chgs_recv | installment_chgs_recv | tracker_chgs_recv | os_principal | os_markup | os_install_flag | installment receiving date | no_of_receipts | session_id | Status | Loan Settelment_Date | ProductDescription | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 209 | 592737 | 6 | 1 | [2014/03/07:12:00:00 AM] | 3469.0 | 1881.0 | 0 | 0 | 0 | 0 | 3469.0 | 1881.0 | 0 | 0 | 0 | 0 | 46531.0 | 12369.0 | N | [2014/03/08:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 1 | 209 | 592737 | 6 | 2 | [2014/04/07:12:00:00 AM] | 3412.0 | 1938.0 | 0 | 0 | 0 | 0 | 3412.0 | 1938.0 | 0 | 0 | 0 | 0 | 43119.0 | 10431.0 | N | [2014/04/07:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 2 | 209 | 592737 | 6 | 3 | [2014/05/07:12:00:00 AM] | 3612.0 | 1738.0 | 0 | 0 | 0 | 0 | 3612.0 | 1738.0 | 0 | 0 | 0 | 0 | 39507.0 | 8693.0 | N | [2014/05/07:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 3 | 209 | 592737 | 6 | 4 | [2014/06/07:12:00:00 AM] | 3705.0 | 1645.0 | 0 | 0 | 0 | 0 | 3705.0 | 1645.0 | 0 | 0 | 0 | 0 | 35802.0 | 7048.0 | N | [2014/06/10:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 4 | 209 | 592737 | 6 | 5 | [2014/07/07:12:00:00 AM] | 3907.0 | 1443.0 | 0 | 0 | 0 | 0 | 3907.0 | 1443.0 | 0 | 0 | 0 | 0 | 31895.0 | 5605.0 | N | [2014/07/08:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 5 | 209 | 592737 | 6 | 6 | [2014/08/07:12:00:00 AM] | 4022.0 | 1328.0 | 0 | 0 | 0 | 0 | 4022.0 | 1328.0 | 0 | 0 | 0 | 0 | 27873.0 | 4277.0 | N | [2014/08/08:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 6 | 209 | 592737 | 6 | 7 | [2014/09/07:12:00:00 AM] | 4189.0 | 1161.0 | 0 | 0 | 0 | 0 | 4189.0 | 1161.0 | 0 | 0 | 0 | 0 | 23684.0 | 3116.0 | N | [2014/09/11:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 7 | 209 | 592737 | 6 | 8 | [2014/10/07:12:00:00 AM] | 4396.0 | 954.0 | 0 | 0 | 0 | 0 | 4396.0 | 954.0 | 0 | 0 | 0 | 0 | 19288.0 | 2162.0 | N | [2014/10/15:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 8 | 209 | 592737 | 6 | 9 | [2014/11/07:12:00:00 AM] | 4547.0 | 803.0 | 0 | 0 | 0 | 0 | 4547.0 | 803.0 | 0 | 0 | 0 | 0 | 14741.0 | 1359.0 | N | [2014/11/11:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
| 9 | 209 | 592737 | 6 | 10 | [2014/12/07:12:00:00 AM] | 4756.0 | 594.0 | 0 | 0 | 0 | 0 | 4756.0 | 594.0 | 0 | 0 | 0 | 0 | 9985.0 | 765.0 | N | [2014/12/11:12:00:00 AM] | 0 | 653770 | X | [2015/02/16:12:00:00 AM] | FINCA KAROBARI KARZA BASIC |
Last rows
| unit_id | business_proposal_no | sub_proposal_no | install_no | install_due_date | principal_amt | markup_amt | insurance_amt | finance_chgs | installment_chgs | tracker_chgs | principal_recv | markup_recv | insurance_recv | finance_chgs_recv | installment_chgs_recv | tracker_chgs_recv | os_principal | os_markup | os_install_flag | installment receiving date | no_of_receipts | session_id | Status | Loan Settelment_Date | ProductDescription | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 933963 | 9042 | 697959 | 1 | 3 | [2020/10/23:12:00:00 AM] | 7163.82 | 3670.18 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 79639.02 | 17858.98 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933964 | 9042 | 697959 | 1 | 4 | [2020/11/23:12:00:00 AM] | 7354.48 | 3479.52 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 72284.54 | 14379.46 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933965 | 9042 | 697959 | 1 | 5 | [2020/12/23:12:00:00 AM] | 7777.68 | 3056.32 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 64506.86 | 11323.14 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933966 | 9042 | 697959 | 1 | 6 | [2021/01/23:12:00:00 AM] | 8015.62 | 2818.38 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 56491.24 | 8504.76 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933967 | 9042 | 697959 | 1 | 7 | [2021/02/23:12:00:00 AM] | 8365.83 | 2468.17 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 48125.41 | 6036.59 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933968 | 9042 | 697959 | 1 | 8 | [2021/03/23:12:00:00 AM] | 8934.83 | 1899.17 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 39190.58 | 4137.42 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933969 | 9042 | 697959 | 1 | 9 | [2021/04/23:12:00:00 AM] | 9121.72 | 1712.28 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 30068.86 | 2425.14 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933970 | 9042 | 697959 | 1 | 10 | [2021/05/24:12:00:00 AM] | 9520.26 | 1313.74 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 20548.60 | 1111.40 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933971 | 9042 | 697959 | 1 | 11 | [2021/06/23:12:00:00 AM] | 9965.17 | 868.83 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 10583.43 | 242.57 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |
| 933972 | 9042 | 697959 | 1 | 12 | [2021/07/23:12:00:00 AM] | 10583.43 | 242.57 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | Y | NaN | 0 | 4011582 | E | [2020/09/24:04:28:36 PM] | FINCA KAROBARI KARZA BASIC 12 MONTHS |